Diagram ADT_General_Objects

Defincja diagramu ADT_General_Objects

Name

ADT_General_Objects

Code

ADT_General_Objects

Comment

Presents general Partient medical treatment concept


Lista tabel diagramu

Name

Code

Agreement

Agreement

AttributeValue

AttributeValue

BehavioralDisfunctionType

BehavioralDisfunctionType

BehavioralDisfunctionTypeText

BehavioralDisfunctionTypeText

CivilInsurance

CivilInsurance

DictionaryValue

DictionaryValue

DisorderItemKind

DisorderItemKind

DisorderItemKindText

DisorderItemKindText

Episode

Episode

EpisodeType

EpisodeType

Event

Event

FormInstance

FormInstance

ICD

ICD

LEpisodeDisorderItem

LEpisodeDisorderItem

LEventICD

LEventICD

LOrderPerfServ

LOrderPerfServ

LOrgUnitResource

LOrgUnitResource

LPerfResPerfContrServ

LPerfResPerfContrServ

LPerfServiceFormInstance

LperfServiceFormInstance

MedicalProductDetails

MedicalProductDetails

NFZContractorCodeDependency

NFZContractorCodeDependency

NFZContractorCodeExclusionRule

NFZContractorCodeExclusionRule

NFZContractServiceData

NFZContractServiceData

NFZContrCodeDependencyType

NFZContrCodeDependencyType

NFZEpisodeData

NFZEpisodeData

NFZSpecificAccounting

NFZSpecificAccounting

NFZTherapyType

NFZTherapyType

OrderItem

OrderItem

Patient

Patient

PatientAgreementType

PatientAgreementType

PatientAgreementTypeText

PatientAgreementTypeText

PerfContractService

PerfContractService

PerfService

PerfService

Referral

Referral

RehabDisfunctionType

RehabDisfunctionType

RehabDisfunctionTypeText

RehabDisfunctionTypeText

ResourceItem

ResourceItem

RuleScope

RuleScope

Unit

Unit


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_220

R_220

Referral

OrderItem

ReferralID

 

 

R_343

R_343

Patient

Episode

PersonID

 

 

R_530

R_530

OrderItem

LOrderPerfServ

OrderID

 

 

R_531

R_531

PerfService

LOrderPerfServ

PerfServiceID

 

 

R_536

R_536

Event

OrderItem

EventID

 

 

R_860

R_860

FormInstance

AttributeValue

FormInstanceID

 

 

R_865

R_865

PerfService

LPerfServiceFormInstance

PerfServiceID

 

 

R_866

R_866

FormInstance

LPerfServiceFormInstance

FormInstanceID

 

 

R_1650

R_1650

NFZSpecificAccounting

NFZContractServiceData

NFZSpecificAccountingID

 

 

R_1660

R_1660

NFZTherapyType

NFZContractServiceData

NFZTherapyTypeID

 

 

R_1661

R_1661

ResourceItem

NFZContractServiceData

ResourceID

 

 

R_1860

R_1860

CivilInsurance

NFZContractServiceData

CivilInsuranceID

 

 

R_1879

R_1879

Referral

LEventICD

ReferralID

 

 

R_6000

R_6000

PatientAgreementType

PatientAgreementTypeText

PatientAgreementTypeID

 

 

R_6001

R_6001

PatientAgreementType

NFZContractServiceData

PatientAgreementTypeID

 

 

R_6002

R_6002

PatientAgreementType

LPerfResPerfContrServ

PatientAgreementTypeID

 

 

R_6028

R_6028

DisorderItemKind

DisorderItemKindText

DisorderItemKindID

 

 

R_6029

R_6029

BehavioralDisfunctionType

BehavioralDisfunctionTypeText

BehavioralDisfunctionTypeID

 

 

R_6030

R_6030

RehabDisfunctionType

RehabDisfunctionTypeText

RehabDisfunctionTypeID

 

 

R_6031

R_6031

DisorderItemKind

LEpisodeDisorderItem

DisorderItemKindID

 

 

R_6032

R_6032

Episode

LEpisodeDisorderItem

EpisodeID

 

 

R_7060

R_7060

ICD

Referral

ICDID

 

 

R_8140

R_8140

ResourceItem

LOrgUnitResource

ResourceID

 

 

R_8380

R_8380

PatientAgreementType

Agreement

PatientAgreementTypeID

 

 

R_8381

R_8381

PerfContractService

Agreement

ContractServicePerfID

 

 

R_8580

R_8580

NFZContrCodeDependencyType

NFZContractorCodeDependency

NFZContrCodeDependencyTypeID

 

 

R_8680

R_8680

MedicalProductDetails

NFZContractServiceData

MedicalProductDetailsID

 

 

R_8973

R_8973

RuleScope

NFZContractorCodeExclusionRule

RuleScopeID

 

 

R_8974

R_8974

EpisodeType

NFZContractorCodeExclusionRule

EpisodeTypeID

 

 

R_10173

R_10173

ICD

NFZEpisodeData

ICD9ID

 

 

R_10174

R_10174

ICD

NFZEpisodeData

ICD10ID

 

 

R_10292

R_10292

DictionaryValue

NFZEpisodeData

NyhaScaleID